77d788681014d43b56e075d2ee21501aa8589eab,zanata-war/src/main/java/org/zanata/dao/TextFlowDAO.java,TextFlowDAO,getTextFlowByDocumentIdWithConstraint,#DocumentId#HLocale#FilterConstraints#number#number#,371

Before Change



      if (hasSearch)
      {
         queryBuilder.append(" and (").append(buildSearchConditionForHQL(constraints.getSearchString(), "tf")); // search in source
         // search in target
         queryBuilder.append(" or exists (")
               .append("from HTextFlowTarget where textFlow = tf and locale = :locale")
               .append(" and ").append(buildSearchConditionForHQL(constraints.getSearchString(), ""))
               .append(")");
         // end search in target
         queryBuilder.append(")"); // end search
      }
      if (!includeAllState)
      {
         // content state restriction
         queryBuilder.append(" and (exists (from HTextFlowTarget where textFlow = tf and locale = :locale and state in (:contentStateList))");
         if (constraints.isIncludeNew())
         {
            queryBuilder.append(" or (:locale not in indices(tf.targets)"); // null target
            if (hasSearch)
            {
               queryBuilder.append(" and ").append(buildSearchConditionForHQL(constraints.getSearchString(), "tf"));
            }
            queryBuilder.append(")"); // end null target condition
         }

After Change


      }
      if (hasSearch)
      {
         textFlowQuery.setParameter(searchStringNamedParam, "%" + constraints.getSearchString().toLowerCase() + "%");
      }
      textFlowQuery.setFirstResult(firstResult).setMaxResults(maxResult);
      textFlowQuery.setCacheable(true).setComment("TextFlowDAO.getTextFlowByDocumentIdWithConstraint");